ALTER TABLE PHYSICIAN ADD FOREIGN KEY (BUILDING_CODE) REFERENCES BUILDING(BUILDING_CODE);
ALTER TABLE PATIENTS ADD FOREIGN KEY (INSURANCE_PLAN_ID) REFERENCES INSURANCE_PLAN(INSURANCE_PLAN_ID);
ALTER TABLE PATIENT_VISIT ADD FOREIGN KEY (PHYSICIAN_CODE) REFERENCES PHYSICIAN(PHYSICIAN_CODE);
ALTER TABLE PATIENT_VISIT ADD FOREIGN KEY (PATIENT_ID) REFERENCES PATIENTS(PATIENT_ID);
ALTER TABLE SCHEDULE ADD FOREIGN KEY (PHYSICIAN_CODE) REFERENCES PHYSICIAN (PHYSICIAN_CODE);
ALTER TABLE WAITLIST ADD FOREIGN KEY (PHYSICIAN_CODE) REFERENCES PHYSICIAN(PHYSICIAN_CODE);
ALTER TABLE WAITLIST ADD FOREIGN KEY (PATIENT_ID) REFERENCES PATIENTS(PATIENT_ID);
ALTER TABLE WAITLIST ADD FOREIGN KEY (INSURANCE_PLAN_ID) REFERENCES INSURANCE_PLAN(INSURANCE_PLAN_ID);
ALTER TABLE WAITLIST ADD FOREIGN KEY (PATIENT_VISIT_ID) REFERENCES PATIENT_VISIT(PATIENT_VISIT_ID);